Skip Headers

Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# NCHR

Syntax

Description of the illustration nchr.gif

Purpose

`NCHR` returns the character having the binary equivalent to `number` in the national character set. The value returned is always `NVARCHAR2`. This function is equivalent to using the `CHR` function with the `USING` `NCHAR_CS` clause.

This function takes as an argument a `NUMBER` value, or any value that can be implicitly converted to `NUMBER`, and returns a character.

See Also: CHR

Examples

The following examples return the nchar character 187:

    SELECT NCHR(187) FROM DUAL;

    NC
    --
    >

    SELECT CHR(187 USING NCHAR_CS) FROM DUAL;

    CH
    --
    >